from sqlalchemy import Column
from sqlalchemy.sql.sqltypes import Integer, String, Text, TIMESTAMP
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class GetPledgeReg(Base):
    __tablename__ = "TYC_GET_PLEDGE_REG"
    PLEDGORNAME = Column(String(255))
    IPRNAME = Column(String(255))
    PLEDGORTYPE = Column(String(255))
    PLEDGEEHID = Column(Integer)
    PLEDGEREGPERIOD = Column(String(255))
    PLEDGEECID = Column(Integer)
    PLEDGORCID = Column(Integer)
    IPRCERTIFICATENUM = Column(String(255))
    PLEDGEETYPE = Column(String(255))
    DETAILLIST = Column(String(4000))
    PLEDGEENAME = Column(String(255))
    PLEDGEID = Column(Integer)
    STATE = Column(String(255))
    ID = Column(Integer,primary_key=True)
    IPRTYPE = Column(String(255))

    ENTNAME = Column(String(100))
    PRIPID = Column(String(36))
    REGNO = Column(String(50))
    UNISCID = Column(String(18))
    CREATE_TIME = Column(TIMESTAMP)
    UPDATE_TIME = Column(TIMESTAMP)